Name Box
displays the current
active cell which is where you cursor is currently located. You can type in a new cell address, and press the Enter key, and Excel will immediately move you to that location.

Formula bar
displays the constant value (a number or text), or formula in the active cell.